﻿CREATE TABLE [DailyPrayers].[Locations]
(
	LocationID int NOT NULL IDENTITY(1,1),
	IsMaster bit NOT NULL,
	InheritMaster bit NOT NULL,
	Name varchar(50) NOT NULL,
	Street varchar(100) NULL,
	Street2 varchar(100) NULL,
	City varchar(50) NULL,
	State varchar(2) NULL,
	ZipCode varchar(10) NULL,
	LongNote text NULL,
	Latitude decimal(8,6) NULL,
	Longitude decimal(8,6) NULL,
	TimeZone int NOT NULL,
	DisplayOrder int NOT NULL
)
